Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	8399
Missing cells	63
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	172.0 B

Variable types

Numeric	9
DateTime	2
Categorical	9
Text	2

Alerts

`Row ID` is uniformly distributed	Uniform
`Row ID` has unique values	Unique
`Discount` has 756 (9.0%) zeros	Zeros

Reproduction

Analysis started	2024-07-09 11:51:30.618550
Analysis finished	2024-07-09 11:51:50.118106
Duration	19.5 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

Row ID
Real number (ℝ)

UNIFORM UNIQUE

Distinct	8399
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4200

Minimum	1
Maximum	8399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	1
5-th percentile	420.9
Q1	2100.5
median	4200
Q3	6299.5
95-th percentile	7979.1
Maximum	8399
Range	8398
Interquartile range (IQR)	4199

Descriptive statistics

Standard deviation	2424.7268
Coefficient of variation (CV)	0.5773159
Kurtosis	-1.2
Mean	4200
Median Absolute Deviation (MAD)	2100
Skewness	0
Sum	35275800
Variance	5879300
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
1317	1	< 0.1%
1315	1	< 0.1%
1199	1	< 0.1%
1155	1	< 0.1%
1109	1	< 0.1%
1007	1	< 0.1%
867	1	< 0.1%
866	1	< 0.1%
698	1	< 0.1%
Other values (8389)	8389	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
8399	1	< 0.1%
8398	1	< 0.1%
8397	1	< 0.1%
8396	1	< 0.1%
8395	1	< 0.1%
8394	1	< 0.1%
8393	1	< 0.1%
8392	1	< 0.1%
8391	1	< 0.1%
8390	1	< 0.1%

Order ID
Real number (ℝ)

Distinct	5496
Distinct (%)	65.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29965.18

Minimum	3
Maximum	59973
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	3
5-th percentile	2818
Q1	15011.5
median	29857
Q3	44596
95-th percentile	57061
Maximum	59973
Range	59970
Interquartile range (IQR)	29584.5

Descriptive statistics

Standard deviation	17260.883
Coefficient of variation (CV)	0.57603137
Kurtosis	-1.1783167
Mean	29965.18
Median Absolute Deviation (MAD)	14778
Skewness	0.0038108922
Sum	2.5167754 × 10⁸
Variance	2.979381 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24132	6	0.1%
43745	6	0.1%
33797	5	0.1%
12261	5	0.1%
58784	5	0.1%
42528	5	0.1%
12067	5	0.1%
13540	5	0.1%
58470	5	0.1%
57253	5	0.1%
Other values (5486)	8347	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
6	1	< 0.1%
32	4	< 0.1%
35	2	< 0.1%
36	1	< 0.1%
65	1	< 0.1%
66	1	< 0.1%
69	2	< 0.1%
70	2	< 0.1%
96	1	< 0.1%

Value	Count	Frequency (%)
59973	2	< 0.1%
59971	3	< 0.1%
59969	2	< 0.1%
59943	1	< 0.1%
59942	1	< 0.1%
59939	1	< 0.1%
59937	1	< 0.1%
59911	1	< 0.1%
59909	2	< 0.1%
59906	1	< 0.1%

Order Date
Date

Distinct	1418
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Minimum	2009-01-01 00:00:00
Maximum	2012-12-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Order Priority
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

High	1768
Low	1720
Not Specified	1672
Medium	1631
Critical	1608

Length

Max length	13
Median length	6
Mean length	6.7410406
Min length	3

Characters and Unicode

Total characters	56618
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Low
2nd row	High
3rd row	High
4th row	High
5th row	Not Specified

Common Values

Value	Count	Frequency (%)
High	1768	21.1%
Low	1720	20.5%
Not Specified	1672	19.9%
Medium	1631	19.4%
Critical	1608	19.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
high	1768	17.6%
low	1720	17.1%
not	1672	16.6%
specified	1672	16.6%
medium	1631	16.2%
critical	1608	16.0%

Most occurring characters

Value	Count	Frequency (%)
i	9959	17.6%
e	4975	8.8%
o	3392	6.0%
d	3303	5.8%
t	3280	5.8%
c	3280	5.8%
H	1768	3.1%
g	1768	3.1%
h	1768	3.1%
L	1720	3.0%
Other values (13)	21405	37.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	44875	79.3%
Uppercase Letter	10071	17.8%
Space Separator	1672	3.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	9959	22.2%
e	4975	11.1%
o	3392	7.6%
d	3303	7.4%
t	3280	7.3%
c	3280	7.3%
g	1768	3.9%
h	1768	3.9%
w	1720	3.8%
f	1672	3.7%
Other values (6)	9758	21.7%

Uppercase Letter

Value	Count	Frequency (%)
H	1768	17.6%
L	1720	17.1%
S	1672	16.6%
N	1672	16.6%
M	1631	16.2%
C	1608	16.0%

Space Separator

Value	Count	Frequency (%)
	1672	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	54946	97.0%
Common	1672	3.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	9959	18.1%
e	4975	9.1%
o	3392	6.2%
d	3303	6.0%
t	3280	6.0%
c	3280	6.0%
H	1768	3.2%
g	1768	3.2%
h	1768	3.2%
L	1720	3.1%
Other values (12)	19733	35.9%

Common

Value	Count	Frequency (%)
	1672	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56618	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	9959	17.6%
e	4975	8.8%
o	3392	6.0%
d	3303	5.8%
t	3280	5.8%
c	3280	5.8%
H	1768	3.1%
g	1768	3.1%
h	1768	3.1%
L	1720	3.0%
Other values (13)	21405	37.8%

Order Quantity
Real number (ℝ)

Distinct	50
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.571735

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	26
Q3	38
95-th percentile	48
Maximum	50
Range	49
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.481071
Coefficient of variation (CV)	0.56629209
Kurtosis	-1.2080203
Mean	25.571735
Median Absolute Deviation (MAD)	13
Skewness	-0.017317782
Sum	214777
Variance	209.70142
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31	202	2.4%
4	196	2.3%
39	195	2.3%
46	193	2.3%
24	192	2.3%
23	192	2.3%
42	189	2.3%
3	189	2.3%
43	184	2.2%
41	183	2.2%
Other values (40)	6484	77.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	165	2.0%
2	152	1.8%
3	189	2.3%
4	196	2.3%
5	166	2.0%
6	172	2.0%
7	174	2.1%
8	176	2.1%
9	155	1.8%
10	170	2.0%

Value	Count	Frequency (%)
50	182	2.2%
49	136	1.6%
48	172	2.0%
47	166	2.0%
46	193	2.3%
45	163	1.9%
44	157	1.9%
43	184	2.2%
42	189	2.3%
41	183	2.2%

Sales
Real number (ℝ)

Distinct	8153
Distinct (%)	97.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1775.8782

Minimum	2.24
Maximum	89061.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	2.24
5-th percentile	34.178
Q1	143.195
median	449.42
Q3	1709.32
95-th percentile	7844.335
Maximum	89061.05
Range	89058.81
Interquartile range (IQR)	1566.125

Descriptive statistics

Standard deviation	3585.0505
Coefficient of variation (CV)	2.018748
Kurtosis	60.928376
Mean	1775.8782
Median Absolute Deviation (MAD)	381.95
Skewness	5.3869824
Sum	14915601
Variance	12852587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74.02	3	< 0.1%
43.29	3	< 0.1%
10.48	3	< 0.1%
224.58	3	< 0.1%
151.19	3	< 0.1%
20.19	3	< 0.1%
127.56	3	< 0.1%
46.94	3	< 0.1%
19.36	3	< 0.1%
75.19	3	< 0.1%
Other values (8143)	8369	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.24	1	< 0.1%
3.2	1	< 0.1%
3.23	1	< 0.1%
3.41	1	< 0.1%
3.42	1	< 0.1%
3.63	1	< 0.1%
3.77	1	< 0.1%
3.85	1	< 0.1%
3.96	1	< 0.1%
4.94	1	< 0.1%

Value	Count	Frequency (%)
89061.05	1	< 0.1%
45923.76	1	< 0.1%
41343.21	1	< 0.1%
33367.85	1	< 0.1%
29884.6	1	< 0.1%
29345.27	1	< 0.1%
29186.49	1	< 0.1%
28761.52	1	< 0.1%
28664.52	1	< 0.1%
28389.14	1	< 0.1%

Discount
Real number (ℝ)

ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049671389

Minimum	0
Maximum	0.25
Zeros	756
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.02
median	0.05
Q3	0.08
95-th percentile	0.1
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.06

Descriptive statistics

Standard deviation	0.03182302
Coefficient of variation (CV)	0.64067102
Kurtosis	-0.95941106
Mean	0.049671389
Median Absolute Deviation (MAD)	0.03
Skewness	0.073916963
Sum	417.19
Variance	0.0010127046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0.01	806	9.6%
0.05	786	9.4%
0.03	779	9.3%
0.09	778	9.3%
0.04	770	9.2%
0.08	765	9.1%
0.02	765	9.1%
0	756	9.0%
0.1	745	8.9%
0.06	734	8.7%
Other values (6)	715	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	756	9.0%
0.01	806	9.6%
0.02	765	9.1%
0.03	779	9.3%
0.04	770	9.2%
0.05	786	9.4%
0.06	734	8.7%
0.07	710	8.5%
0.08	765	9.1%
0.09	778	9.3%

Value	Count	Frequency (%)
0.25	1	< 0.1%
0.21	1	< 0.1%
0.17	1	< 0.1%
0.16	1	< 0.1%
0.11	1	< 0.1%
0.1	745	8.9%
0.09	778	9.3%
0.08	765	9.1%
0.07	710	8.5%
0.06	734	8.7%

Ship Mode
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Regular Air	6270
Delivery Truck	1146
Express Air	983

Length

Max length	14
Median length	11
Mean length	11.409334
Min length	11

Characters and Unicode

Total characters	95827
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Regular Air
2nd row	Delivery Truck
3rd row	Regular Air
4th row	Regular Air
5th row	Regular Air

Common Values

Value	Count	Frequency (%)
Regular Air	6270	74.7%
Delivery Truck	1146	13.6%
Express Air	983	11.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
air	7253	43.2%
regular	6270	37.3%
delivery	1146	6.8%
truck	1146	6.8%
express	983	5.9%

Most occurring characters

Value	Count	Frequency (%)
r	16798	17.5%
e	9545	10.0%
	8399	8.8%
i	8399	8.8%
u	7416	7.7%
l	7416	7.7%
A	7253	7.6%
R	6270	6.5%
g	6270	6.5%
a	6270	6.5%
Other values (10)	11791	12.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	70630	73.7%
Uppercase Letter	16798	17.5%
Space Separator	8399	8.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	16798	23.8%
e	9545	13.5%
i	8399	11.9%
u	7416	10.5%
l	7416	10.5%
g	6270	8.9%
a	6270	8.9%
s	1966	2.8%
v	1146	1.6%
y	1146	1.6%
Other values (4)	4258	6.0%

Uppercase Letter

Value	Count	Frequency (%)
A	7253	43.2%
R	6270	37.3%
T	1146	6.8%
D	1146	6.8%
E	983	5.9%

Space Separator

Value	Count	Frequency (%)
	8399	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	87428	91.2%
Common	8399	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	16798	19.2%
e	9545	10.9%
i	8399	9.6%
u	7416	8.5%
l	7416	8.5%
A	7253	8.3%
R	6270	7.2%
g	6270	7.2%
a	6270	7.2%
s	1966	2.2%
Other values (9)	9825	11.2%

Common

Value	Count	Frequency (%)
	8399	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	95827	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	16798	17.5%
e	9545	10.0%
	8399	8.8%
i	8399	8.8%
u	7416	7.7%
l	7416	7.7%
A	7253	7.6%
R	6270	6.5%
g	6270	6.5%
a	6270	6.5%
Other values (10)	11791	12.3%

Profit
Real number (ℝ)

Distinct	7986
Distinct (%)	95.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	181.18442

Minimum	-14140.702
Maximum	27220.69
Zeros	0
Zeros (%)	0.0%
Negative	4264
Negative (%)	50.8%
Memory size	65.7 KiB

Quantile statistics

Minimum	-14140.702
5-th percentile	-592.43905
Q1	-83.315
median	-1.5
Q3	162.748
95-th percentile	1542.309
Maximum	27220.69
Range	41361.392
Interquartile range (IQR)	246.063

Descriptive statistics

Standard deviation	1196.6533
Coefficient of variation (CV)	6.6046149
Kurtosis	67.34971
Mean	181.18442
Median Absolute Deviation (MAD)	104.3345
Skewness	3.6472388
Sum	1521768
Variance	1431979.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-969.048366	8	0.1%
-433.290143	6	0.1%
11.65095	5	0.1%
-715.778206	5	0.1%
-1331.553366	5	0.1%
-528.653125	5	0.1%
-505.984479	5	0.1%
-66.87	4	< 0.1%
-513.79042	4	< 0.1%
-22.82	4	< 0.1%
Other values (7976)	8348	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-14140.7016	1	< 0.1%
-12557.9976	1	< 0.1%
-11984.3979	1	< 0.1%
-11861.46	1	< 0.1%
-11769.17	1	< 0.1%
-11053.6	1	< 0.1%
-10263.6597	1	< 0.1%
-9611.91	1	< 0.1%
-9078.94	1	< 0.1%
-8570.4483	1	< 0.1%

Value	Count	Frequency (%)
27220.69	1	< 0.1%
14440.39	1	< 0.1%
13340.26	1	< 0.1%
12748.86	1	< 0.1%
12606.81	1	< 0.1%
11984.395	1	< 0.1%
11630.146	1	< 0.1%
11562.08	1	< 0.1%
11535.282	1	< 0.1%
10951.3065	1	< 0.1%

Unit Price
Real number (ℝ)

Distinct	751
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	89.346259

Minimum	0.99
Maximum	6783.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0.99
5-th percentile	2.88
Q1	6.48
median	20.99
Q3	85.99
95-th percentile	320.64
Maximum	6783.02
Range	6782.03
Interquartile range (IQR)	79.51

Descriptive statistics

Standard deviation	290.35438
Coefficient of variation (CV)	3.2497654
Kurtosis	271.16873
Mean	89.346259
Median Absolute Deviation (MAD)	17.01
Skewness	14.127793
Sum	750419.23
Variance	84305.668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.48	264	3.1%
65.99	192	2.3%
4.98	136	1.6%
125.99	115	1.4%
5.98	102	1.2%
2.88	81	1.0%
30.98	73	0.9%
20.99	73	0.9%
35.99	70	0.8%
19.98	66	0.8%
Other values (741)	7227	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.99	2	< 0.1%
1.14	10	0.1%
1.26	13	0.2%
1.48	12	0.1%
1.6	5	0.1%
1.68	22	0.3%
1.7	8	0.1%
1.74	9	0.1%
1.76	29	0.3%
1.8	3	< 0.1%

Value	Count	Frequency (%)
6783.02	7	0.1%
3502.14	6	0.1%
3499.99	7	0.1%
2550.14	7	0.1%
2036.48	6	0.1%
1938.02	8	0.1%
1889.99	3	< 0.1%
1637.53	2	< 0.1%
1500.97	5	0.1%
1360.14	3	< 0.1%

Shipping Cost
Real number (ℝ)

Distinct	652
Distinct (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.838557

Minimum	0.49
Maximum	164.73
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0.49
5-th percentile	0.8
Q1	3.3
median	6.07
Q3	13.99
95-th percentile	55.351
Maximum	164.73
Range	164.24
Interquartile range (IQR)	10.69

Descriptive statistics

Standard deviation	17.264052
Coefficient of variation (CV)	1.3447035
Kurtosis	7.7515872
Mean	12.838557
Median Absolute Deviation (MAD)	3.61
Skewness	2.5538008
Sum	107831.04
Variance	298.04749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.99	352	4.2%
8.99	321	3.8%
1.99	247	2.9%
0.5	190	2.3%
0.99	144	1.7%
4	143	1.7%
1.49	138	1.6%
0.7	138	1.6%
24.49	132	1.6%
2.99	124	1.5%
Other values (642)	6470	77.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.49	34	0.4%
0.5	190	2.3%
0.7	138	1.6%
0.71	22	0.3%
0.73	1	< 0.1%
0.75	7	0.1%
0.76	7	0.1%
0.78	7	0.1%
0.79	3	< 0.1%
0.8	24	0.3%

Value	Count	Frequency (%)
164.73	1	< 0.1%
154.12	1	< 0.1%
147.12	2	< 0.1%
143.71	1	< 0.1%
130	1	< 0.1%
126	1	< 0.1%
110.2	10	0.1%
99	7	0.1%
91.05	5	0.1%
89.3	13	0.2%

Customer Name
Text

Distinct	795
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Length

Max length	22
Median length	19
Mean length	12.867127
Min length	7

Characters and Unicode

Total characters	108071
Distinct characters	53
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	0.1%

Sample

1st row	Muhammed MacIntyre
2nd row	Barry French
3rd row	Barry French
4th row	Clay Rozendal
5th row	Carlos Soltero

Value	Count	Frequency (%)
michael	105	0.6%
john	93	0.6%
brown	93	0.6%
liz	87	0.5%
michelle	86	0.5%
jones	86	0.5%
patrick	83	0.5%
bill	80	0.5%
alan	77	0.5%
price	75	0.4%
Other values (895)	15961	94.9%

Most occurring characters

Value	Count	Frequency (%)
a	10075	9.3%
e	9451	8.7%
n	8461	7.8%
	8427	7.8%
r	7919	7.3%
i	6569	6.1%
l	5720	5.3%
o	5302	4.9%
t	4465	4.1%
s	3528	3.3%
Other values (43)	38154	35.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	82315	76.2%
Uppercase Letter	17202	15.9%
Space Separator	8427	7.8%
Other Punctuation	127	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	1563	9.1%
B	1510	8.8%
M	1487	8.6%
S	1487	8.6%
D	1121	6.5%
J	1009	5.9%
A	988	5.7%
P	880	5.1%
H	796	4.6%
T	784	4.6%
Other values (16)	5577	32.4%

Lowercase Letter

Value	Count	Frequency (%)
a	10075	12.2%
e	9451	11.5%
n	8461	10.3%
r	7919	9.6%
i	6569	8.0%
l	5720	6.9%
o	5302	6.4%
t	4465	5.4%
s	3528	4.3%
h	3269	4.0%
Other values (15)	17556	21.3%

Space Separator

Value	Count	Frequency (%)
	8427	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	127	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	99517	92.1%
Common	8554	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	10075	10.1%
e	9451	9.5%
n	8461	8.5%
r	7919	8.0%
i	6569	6.6%
l	5720	5.7%
o	5302	5.3%
t	4465	4.5%
s	3528	3.5%
h	3269	3.3%
Other values (41)	34758	34.9%

Common

Value	Count	Frequency (%)
	8427	98.5%
'	127	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	108071	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	10075	9.3%
e	9451	8.7%
n	8461	7.8%
	8427	7.8%
r	7919	7.3%
i	6569	6.1%
l	5720	5.3%
o	5302	4.9%
t	4465	4.1%
s	3528	3.3%
Other values (43)	38154	35.3%

Province
Categorical

Distinct	13
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Ontario	1826
British Columbia	1126
Saskachewan	913
Alberta	865
Manitoba	793
Other values (8)	2876

Length

Max length	21
Median length	16
Mean length	9.9976188
Min length	5

Characters and Unicode

Total characters	83970
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nunavut
2nd row	Nunavut
3rd row	Nunavut
4th row	Nunavut
5th row	Nunavut

Common Values

Value	Count	Frequency (%)
Ontario	1826	21.7%
British Columbia	1126	13.4%
Saskachewan	913	10.9%
Alberta	865	10.3%
Manitoba	793	9.4%
Quebec	781	9.3%
Yukon	542	6.5%
Nova Scotia	464	5.5%
Northwest Territories	394	4.7%
New Brunswick	323	3.8%
Other values (3)	372	4.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ontario	1826	16.4%
british	1126	10.1%
columbia	1126	10.1%
saskachewan	913	8.2%
alberta	865	7.8%
manitoba	793	7.1%
quebec	781	7.0%
yukon	542	4.9%
scotia	464	4.2%
nova	464	4.2%
Other values (9)	2228	20.0%

Most occurring characters

Value	Count	Frequency (%)
a	9653	11.5%
i	7783	9.3%
t	6335	7.5%
r	6138	7.3%
o	6085	7.2%
e	5138	6.1%
n	5062	6.0%
b	3565	4.2%
s	3361	4.0%
u	3012	3.6%
Other values (23)	27838	33.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	70113	83.5%
Uppercase Letter	11128	13.3%
Space Separator	2729	3.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	9653	13.8%
i	7783	11.1%
t	6335	9.0%
r	6138	8.8%
o	6085	8.7%
e	5138	7.3%
n	5062	7.2%
b	3565	5.1%
s	3361	4.8%
u	3012	4.3%
Other values (9)	13981	19.9%

Uppercase Letter

Value	Count	Frequency (%)
O	1826	16.4%
B	1449	13.0%
S	1377	12.4%
N	1342	12.1%
C	1126	10.1%
A	865	7.8%
M	793	7.1%
Q	781	7.0%
Y	542	4.9%
T	394	3.5%
Other values (3)	633	5.7%

Space Separator

Value	Count	Frequency (%)
	2729	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	81241	96.8%
Common	2729	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	9653	11.9%
i	7783	9.6%
t	6335	7.8%
r	6138	7.6%
o	6085	7.5%
e	5138	6.3%
n	5062	6.2%
b	3565	4.4%
s	3361	4.1%
u	3012	3.7%
Other values (22)	25109	30.9%

Common

Value	Count	Frequency (%)
	2729	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	83970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	9653	11.5%
i	7783	9.3%
t	6335	7.5%
r	6138	7.3%
o	6085	7.2%
e	5138	6.1%
n	5062	6.0%
b	3565	4.2%
s	3361	4.0%
u	3012	3.6%
Other values (23)	27838	33.2%

Region
Categorical

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

West	1991
Ontario	1826
Prarie	1706
Atlantic	1080
Quebec	781
Other values (3)	1015

Length

Max length	21
Median length	8
Mean length	6.6490058
Min length	4

Characters and Unicode

Total characters	55845
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nunavut
2nd row	Nunavut
3rd row	Nunavut
4th row	Nunavut
5th row	Nunavut

Common Values

Value	Count	Frequency (%)
West	1991	23.7%
Ontario	1826	21.7%
Prarie	1706	20.3%
Atlantic	1080	12.9%
Quebec	781	9.3%
Yukon	542	6.5%
Northwest Territories	394	4.7%
Nunavut	79	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	1991	22.6%
ontario	1826	20.8%
prarie	1706	19.4%
atlantic	1080	12.3%
quebec	781	8.9%
yukon	542	6.2%
northwest	394	4.5%
territories	394	4.5%
nunavut	79	0.9%

Most occurring characters

Value	Count	Frequency (%)
t	7238	13.0%
r	6814	12.2%
e	6441	11.5%
i	5400	9.7%
a	4691	8.4%
n	3527	6.3%
o	3156	5.7%
s	2779	5.0%
W	1991	3.6%
c	1861	3.3%
Other values (15)	11947	21.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	46658	83.5%
Uppercase Letter	8793	15.7%
Space Separator	394	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	7238	15.5%
r	6814	14.6%
e	6441	13.8%
i	5400	11.6%
a	4691	10.1%
n	3527	7.6%
o	3156	6.8%
s	2779	6.0%
c	1861	4.0%
u	1481	3.2%
Other values (6)	3270	7.0%

Uppercase Letter

Value	Count	Frequency (%)
W	1991	22.6%
O	1826	20.8%
P	1706	19.4%
A	1080	12.3%
Q	781	8.9%
Y	542	6.2%
N	473	5.4%
T	394	4.5%

Space Separator

Value	Count	Frequency (%)
	394	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	55451	99.3%
Common	394	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	7238	13.1%
r	6814	12.3%
e	6441	11.6%
i	5400	9.7%
a	4691	8.5%
n	3527	6.4%
o	3156	5.7%
s	2779	5.0%
W	1991	3.6%
c	1861	3.4%
Other values (14)	11553	20.8%

Common

Value	Count	Frequency (%)
	394	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55845	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	7238	13.0%
r	6814	12.2%
e	6441	11.5%
i	5400	9.7%
a	4691	8.4%
n	3527	6.3%
o	3156	5.7%
s	2779	5.0%
W	1991	3.6%
c	1861	3.3%
Other values (15)	11947	21.4%

Customer Segment
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Corporate	3076
Home Office	2032
Consumer	1649
Small Business	1642

Length

Max length	14
Median length	11
Mean length	10.265032
Min length	8

Characters and Unicode

Total characters	86216
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Small Business
2nd row	Consumer
3rd row	Consumer
4th row	Corporate
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Corporate	3076	36.6%
Home Office	2032	24.2%
Consumer	1649	19.6%
Small Business	1642	19.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
corporate	3076	25.5%
home	2032	16.8%
office	2032	16.8%
consumer	1649	13.7%
small	1642	13.6%
business	1642	13.6%

Most occurring characters

Value	Count	Frequency (%)
e	10431	12.1%
o	9833	11.4%
r	7801	9.0%
s	6575	7.6%
m	5323	6.2%
C	4725	5.5%
a	4718	5.5%
f	4064	4.7%
	3674	4.3%
i	3674	4.3%
Other values (10)	25398	29.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	70469	81.7%
Uppercase Letter	12073	14.0%
Space Separator	3674	4.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10431	14.8%
o	9833	14.0%
r	7801	11.1%
s	6575	9.3%
m	5323	7.6%
a	4718	6.7%
f	4064	5.8%
i	3674	5.2%
u	3291	4.7%
n	3291	4.7%
Other values (4)	11468	16.3%

Uppercase Letter

Value	Count	Frequency (%)
C	4725	39.1%
O	2032	16.8%
H	2032	16.8%
S	1642	13.6%
B	1642	13.6%

Space Separator

Value	Count	Frequency (%)
	3674	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	82542	95.7%
Common	3674	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10431	12.6%
o	9833	11.9%
r	7801	9.5%
s	6575	8.0%
m	5323	6.4%
C	4725	5.7%
a	4718	5.7%
f	4064	4.9%
i	3674	4.5%
u	3291	4.0%
Other values (9)	22107	26.8%

Common

Value	Count	Frequency (%)
	3674	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	10431	12.1%
o	9833	11.4%
r	7801	9.0%
s	6575	7.6%
m	5323	6.2%
C	4725	5.5%
a	4718	5.5%
f	4064	4.7%
	3674	4.3%
i	3674	4.3%
Other values (10)	25398	29.5%

Product Category
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Office Supplies	4610
Technology	2065
Furniture	1724

Length

Max length	15
Median length	15
Mean length	12.539112
Min length	9

Characters and Unicode

Total characters	105316
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Office Supplies
2nd row	Office Supplies
3rd row	Office Supplies
4th row	Technology
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	4610	54.9%
Technology	2065	24.6%
Furniture	1724	20.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	4610	35.4%
supplies	4610	35.4%
technology	2065	15.9%
furniture	1724	13.3%

Most occurring characters

Value	Count	Frequency (%)
e	13009	12.4%
i	10944	10.4%
p	9220	8.8%
f	9220	8.8%
u	8058	7.7%
c	6675	6.3%
l	6675	6.3%
O	4610	4.4%
s	4610	4.4%
S	4610	4.4%
Other values (10)	27685	26.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	87697	83.3%
Uppercase Letter	13009	12.4%
Space Separator	4610	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	13009	14.8%
i	10944	12.5%
p	9220	10.5%
f	9220	10.5%
u	8058	9.2%
c	6675	7.6%
l	6675	7.6%
s	4610	5.3%
o	4130	4.7%
n	3789	4.3%
Other values (5)	11367	13.0%

Uppercase Letter

Value	Count	Frequency (%)
O	4610	35.4%
S	4610	35.4%
T	2065	15.9%
F	1724	13.3%

Space Separator

Value	Count	Frequency (%)
	4610	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	100706	95.6%
Common	4610	4.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	13009	12.9%
i	10944	10.9%
p	9220	9.2%
f	9220	9.2%
u	8058	8.0%
c	6675	6.6%
l	6675	6.6%
O	4610	4.6%
s	4610	4.6%
S	4610	4.6%
Other values (9)	23075	22.9%

Common

Value	Count	Frequency (%)
	4610	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	105316	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	13009	12.4%
i	10944	10.4%
p	9220	8.8%
f	9220	8.8%
u	8058	7.7%
c	6675	6.3%
l	6675	6.3%
O	4610	4.4%
s	4610	4.4%
S	4610	4.4%
Other values (10)	27685	26.3%

Product Sub-Category
Categorical

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Paper	1225
Binders and Binder Accessories	915
Telephones and Communication	883
Office Furnishings	788
Computer Peripherals	758
Other values (12)	3830

Length

Max length	30
Median length	20
Mean length	17.080962
Min length	5

Characters and Unicode

Total characters	143463
Distinct characters	37
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Storage & Organization
2nd row	Appliances
3rd row	Binders and Binder Accessories
4th row	Telephones and Communication
5th row	Appliances

Common Values

Value	Count	Frequency (%)
Paper	1225	14.6%
Binders and Binder Accessories	915	10.9%
Telephones and Communication	883	10.5%
Office Furnishings	788	9.4%
Computer Peripherals	758	9.0%
Pens & Art Supplies	633	7.5%
Storage & Organization	546	6.5%
Appliances	434	5.2%
Chairs & Chairmats	386	4.6%
Tables	361	4.3%
Other values (7)	1470	17.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	2029	10.5%
	1565	8.1%
paper	1225	6.3%
office	1125	5.8%
binders	915	4.7%
binder	915	4.7%
accessories	915	4.7%
telephones	883	4.6%
communication	883	4.6%
furnishings	788	4.1%
Other values (22)	8098	41.9%

Most occurring characters

Value	Count	Frequency (%)
e	15400	10.7%
s	11945	8.3%
i	11613	8.1%
n	11005	7.7%
	10942	7.6%
r	10371	7.2%
a	9566	6.7%
o	6269	4.4%
p	6091	4.2%
c	4942	3.4%
Other values (27)	45319	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	115065	80.2%
Uppercase Letter	15747	11.0%
Space Separator	10942	7.6%
Other Punctuation	1709	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	15400	13.4%
s	11945	10.4%
i	11613	10.1%
n	11005	9.6%
r	10371	9.0%
a	9566	8.3%
o	6269	5.4%
p	6091	5.3%
c	4942	4.3%
d	4038	3.5%
Other values (12)	23825	20.7%

Uppercase Letter

Value	Count	Frequency (%)
P	2616	16.6%
C	2500	15.9%
B	2198	14.0%
A	1982	12.6%
O	1671	10.6%
T	1388	8.8%
S	1323	8.4%
F	875	5.6%
M	337	2.1%
R	323	2.1%
Other values (2)	534	3.4%

Other Punctuation

Value	Count	Frequency (%)
&	1565	91.6%
,	144	8.4%

Space Separator

Value	Count	Frequency (%)
	10942	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	130812	91.2%
Common	12651	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	15400	11.8%
s	11945	9.1%
i	11613	8.9%
n	11005	8.4%
r	10371	7.9%
a	9566	7.3%
o	6269	4.8%
p	6091	4.7%
c	4942	3.8%
d	4038	3.1%
Other values (24)	39572	30.3%

Common

Value	Count	Frequency (%)
	10942	86.5%
&	1565	12.4%
,	144	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	143463	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	15400	10.7%
s	11945	8.3%
i	11613	8.1%
n	11005	7.7%
	10942	7.6%
r	10371	7.2%
a	9566	6.7%
o	6269	4.4%
p	6091	4.2%
c	4942	3.4%
Other values (27)	45319	31.6%

Product Name
Text

Distinct	1263
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Length

Max length	98
Median length	75
Mean length	34.351709
Min length	3

Characters and Unicode

Total characters	288520
Distinct characters	84
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	0.7%

Sample

1st row	Eldon Base for stackable storage shelf, platinum
2nd row	1.7 Cubic Foot Compact "Cube" Office Refrigerators
3rd row	Cardinal Slant-D® Ring Binder, Heavy Gauge Vinyl
4th row	R380
5th row	Holmes HEPA Air Purifier

Value	Count	Frequency (%)
xerox	765	1.8%
x	499	1.2%
avery	418	1.0%
with	405	0.9%
black	338	0.8%
	327	0.8%
binders	305	0.7%
for	302	0.7%
chair	276	0.6%
keyboard	268	0.6%
Other values (2076)	38861	90.9%

Most occurring characters

Value	Count	Frequency (%)
	34365	11.9%
e	25862	9.0%
r	15875	5.5%
o	15517	5.4%
a	14627	5.1%
i	14001	4.9%
l	12489	4.3%
t	12482	4.3%
n	11792	4.1%
s	11438	4.0%
Other values (74)	120072	41.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	184442	63.9%
Uppercase Letter	42833	14.8%
Space Separator	34365	11.9%
Decimal Number	16531	5.7%
Other Punctuation	6372	2.2%
Dash Punctuation	2329	0.8%
Other Symbol	1374	0.5%
Final Punctuation	69	< 0.1%
Close Punctuation	68	< 0.1%
Open Punctuation	68	< 0.1%
Other values (2)	69	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	25862	14.0%
r	15875	8.6%
o	15517	8.4%
a	14627	7.9%
i	14001	7.6%
l	12489	6.8%
t	12482	6.8%
n	11792	6.4%
s	11438	6.2%
c	7441	4.0%
Other values (17)	42918	23.3%

Uppercase Letter

Value	Count	Frequency (%)
S	4518	10.5%
C	4434	10.4%
P	4013	9.4%
B	3859	9.0%
D	2625	6.1%
A	2478	5.8%
M	2403	5.6%
F	2020	4.7%
T	1985	4.6%
R	1664	3.9%
Other values (16)	12834	30.0%

Decimal Number

Value	Count	Frequency (%)
1	3209	19.4%
0	2724	16.5%
2	1984	12.0%
3	1528	9.2%
8	1410	8.5%
4	1406	8.5%
9	1255	7.6%
5	1142	6.9%
6	943	5.7%
7	930	5.6%

Other Punctuation

Value	Count	Frequency (%)
,	2856	44.8%
/	1359	21.3%
"	1060	16.6%
.	520	8.2%
&	216	3.4%
'	149	2.3%
#	104	1.6%
*	59	0.9%
%	45	0.7%
;	4	0.1%

Other Symbol

Value	Count	Frequency (%)
®	896	65.2%
™	478	34.8%

Close Punctuation

Value	Count	Frequency (%)
)	53	77.9%
]	15	22.1%

Open Punctuation

Value	Count	Frequency (%)
(	53	77.9%
[	15	22.1%

Space Separator

Value	Count	Frequency (%)
	34365	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2329	100.0%

Final Punctuation

Value	Count	Frequency (%)
”	69	100.0%

Math Symbol

Value	Count	Frequency (%)
+	40	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	227275	78.8%
Common	61245	21.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	25862	11.4%
r	15875	7.0%
o	15517	6.8%
a	14627	6.4%
i	14001	6.2%
l	12489	5.5%
t	12482	5.5%
n	11792	5.2%
s	11438	5.0%
c	7441	3.3%
Other values (43)	85751	37.7%

Common

Value	Count	Frequency (%)
	34365	56.1%
1	3209	5.2%
,	2856	4.7%
0	2724	4.4%
-	2329	3.8%
2	1984	3.2%
3	1528	2.5%
8	1410	2.3%
4	1406	2.3%
/	1359	2.2%
Other values (21)	8075	13.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	287046	99.5%
None	898	0.3%
Letterlike Symbols	478	0.2%
Punctuation	98	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	34365	12.0%
e	25862	9.0%
r	15875	5.5%
o	15517	5.4%
a	14627	5.1%
i	14001	4.9%
l	12489	4.4%
t	12482	4.3%
n	11792	4.1%
s	11438	4.0%
Other values (69)	118598	41.3%

None

Value	Count	Frequency (%)
®	896	99.8%
à	2	0.2%

Letterlike Symbols

Value	Count	Frequency (%)
™	478	100.0%

Punctuation

Value	Count	Frequency (%)
”	69	70.4%
“	29	29.6%

Product Container
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Small Box	4347
Wrap Bag	1168
Small Pack	956
Jumbo Drum	624
Jumbo Box	532
Other values (2)	772

Length

Max length	10
Median length	9
Mean length	9.0926301
Min length	8

Characters and Unicode

Total characters	76369
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Large Box
2nd row	Jumbo Drum
3rd row	Small Box
4th row	Small Box
5th row	Medium Box

Common Values

Value	Count	Frequency (%)
Small Box	4347	51.8%
Wrap Bag	1168	13.9%
Small Pack	956	11.4%
Jumbo Drum	624	7.4%
Jumbo Box	532	6.3%
Large Box	406	4.8%
Medium Box	366	4.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
box	5651	33.6%
small	5303	31.6%
wrap	1168	7.0%
bag	1168	7.0%
jumbo	1156	6.9%
pack	956	5.7%
drum	624	3.7%
large	406	2.4%
medium	366	2.2%

Most occurring characters

Value	Count	Frequency (%)
l	10606	13.9%
a	9001	11.8%
	8399	11.0%
m	7449	9.8%
B	6819	8.9%
o	6807	8.9%
x	5651	7.4%
S	5303	6.9%
r	2198	2.9%
u	2146	2.8%
Other values (14)	11990	15.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51172	67.0%
Uppercase Letter	16798	22.0%
Space Separator	8399	11.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	10606	20.7%
a	9001	17.6%
m	7449	14.6%
o	6807	13.3%
x	5651	11.0%
r	2198	4.3%
u	2146	4.2%
g	1574	3.1%
p	1168	2.3%
b	1156	2.3%
Other values (5)	3416	6.7%

Uppercase Letter

Value	Count	Frequency (%)
B	6819	40.6%
S	5303	31.6%
W	1168	7.0%
J	1156	6.9%
P	956	5.7%
D	624	3.7%
L	406	2.4%
M	366	2.2%

Space Separator

Value	Count	Frequency (%)
	8399	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	67970	89.0%
Common	8399	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	10606	15.6%
a	9001	13.2%
m	7449	11.0%
B	6819	10.0%
o	6807	10.0%
x	5651	8.3%
S	5303	7.8%
r	2198	3.2%
u	2146	3.2%
g	1574	2.3%
Other values (13)	10416	15.3%

Common

Value	Count	Frequency (%)
	8399	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	76369	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	10606	13.9%
a	9001	11.8%
	8399	11.0%
m	7449	9.8%
B	6819	8.9%
o	6807	8.9%
x	5651	7.4%
S	5303	6.9%
r	2198	2.9%
u	2146	2.8%
Other values (14)	11990	15.7%

Product Base Margin
Real number (ℝ)

Distinct	51
Distinct (%)	0.6%
Missing	63
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.5125132

Minimum	0.35
Maximum	0.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.7 KiB

Quantile statistics

Minimum	0.35
5-th percentile	0.36
Q1	0.38
median	0.52
Q3	0.59
95-th percentile	0.78
Maximum	0.85
Range	0.5
Interquartile range (IQR)	0.21

Descriptive statistics

Standard deviation	0.13558894
Coefficient of variation (CV)	0.26455698
Kurtosis	-0.66087023
Mean	0.5125132
Median Absolute Deviation (MAD)	0.12
Skewness	0.55939959
Sum	4272.31
Variance	0.018384361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.37	761	9.1%
0.38	678	8.1%
0.36	628	7.5%
0.59	497	5.9%
0.39	482	5.7%
0.57	459	5.5%
0.56	459	5.5%
0.4	408	4.9%
0.58	387	4.6%
0.55	314	3.7%
Other values (41)	3263	38.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.35	262	3.1%
0.36	628	7.5%
0.37	761	9.1%
0.38	678	8.1%
0.39	482	5.7%
0.4	408	4.9%
0.41	98	1.2%
0.42	78	0.9%
0.43	101	1.2%
0.44	94	1.1%

Value	Count	Frequency (%)
0.85	36	0.4%
0.84	25	0.3%
0.83	83	1.0%
0.82	32	0.4%
0.81	73	0.9%
0.8	48	0.6%
0.79	68	0.8%
0.78	89	1.1%
0.77	68	0.8%
0.76	55	0.7%

Ship Date
Date

Distinct	1450
Distinct (%)	17.3%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

Minimum	2009-01-02 00:00:00
Maximum	2012-12-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Year
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.7 KiB

2009	2153
2010	2142
2012	2102
2011	2002

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	33596
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2010
2nd row	2012
3rd row	2012
4th row	2011
5th row	2010

Common Values

Value	Count	Frequency (%)
2009	2153	25.6%
2010	2142	25.5%
2012	2102	25.0%
2011	2002	23.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2009	2153	25.6%
2010	2142	25.5%
2012	2102	25.0%
2011	2002	23.8%

Most occurring characters

Value	Count	Frequency (%)
0	12694	37.8%
2	10501	31.3%
1	8248	24.6%
9	2153	6.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33596	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12694	37.8%
2	10501	31.3%
1	8248	24.6%
9	2153	6.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	33596	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12694	37.8%
2	10501	31.3%
1	8248	24.6%
9	2153	6.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33596	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12694	37.8%
2	10501	31.3%
1	8248	24.6%
9	2153	6.4%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Row ID	Order ID	Order Date	Order Priority	Order Quantity	Sales	Discount	Ship Mode	Profit	Unit Price	Shipping Cost	Customer Name	Province	Region	Customer Segment	Product Category	Product Sub-Category	Product Name	Product Container	Product Base Margin	Ship Date	Year
0	1	3	2010-10-13	Low	6	261.5400	0.04	Regular Air	-213.2500	38.94	35.00	Muhammed MacIntyre	Nunavut	Nunavut	Small Business	Office Supplies	Storage & Organization	Eldon Base for stackable storage shelf, platinum	Large Box	0.80	2010-10-20	2010
1	49	293	2012-10-01	High	49	10123.0200	0.07	Delivery Truck	457.8100	208.16	68.02	Barry French	Nunavut	Nunavut	Consumer	Office Supplies	Appliances	1.7 Cubic Foot Compact "Cube" Office Refrigerators	Jumbo Drum	0.58	2012-10-02	2012
2	50	293	2012-10-01	High	27	244.5700	0.01	Regular Air	46.7075	8.69	2.99	Barry French	Nunavut	Nunavut	Consumer	Office Supplies	Binders and Binder Accessories	Cardinal Slant-D® Ring Binder, Heavy Gauge Vinyl	Small Box	0.39	2012-10-03	2012
3	80	483	2011-07-10	High	30	4965.7595	0.08	Regular Air	1198.9710	195.99	3.99	Clay Rozendal	Nunavut	Nunavut	Corporate	Technology	Telephones and Communication	R380	Small Box	0.58	2011-07-12	2011
4	85	515	2010-08-28	Not Specified	19	394.2700	0.08	Regular Air	30.9400	21.78	5.94	Carlos Soltero	Nunavut	Nunavut	Consumer	Office Supplies	Appliances	Holmes HEPA Air Purifier	Medium Box	0.50	2010-08-30	2010
5	86	515	2010-08-28	Not Specified	21	146.6900	0.05	Regular Air	4.4300	6.64	4.95	Carlos Soltero	Nunavut	Nunavut	Consumer	Furniture	Office Furnishings	G.E. Longer-Life Indoor Recessed Floodlight Bulbs	Small Pack	0.37	2010-08-30	2010
6	97	613	2011-06-17	High	12	93.5400	0.03	Regular Air	-54.0385	7.30	7.72	Carl Jackson	Nunavut	Nunavut	Corporate	Office Supplies	Binders and Binder Accessories	Angle-D Binders with Locking Rings, Label Holders	Small Box	0.38	2011-06-17	2011
7	98	613	2011-06-17	High	22	905.0800	0.09	Regular Air	127.7000	42.76	6.22	Carl Jackson	Nunavut	Nunavut	Corporate	Office Supplies	Storage & Organization	SAFCO Mobile Desk Side File, Wire Frame	Small Box	NaN	2011-06-18	2011
8	103	643	2011-03-24	High	21	2781.8200	0.07	Express Air	-695.2600	138.14	35.00	Monica Federle	Nunavut	Nunavut	Corporate	Office Supplies	Storage & Organization	SAFCO Commercial Wire Shelving, Black	Large Box	NaN	2011-03-25	2011
9	107	678	2010-02-26	Low	44	228.4100	0.07	Regular Air	-226.3600	4.98	8.33	Dorothy Badders	Nunavut	Nunavut	Home Office	Office Supplies	Paper	Xerox 198	Small Box	0.38	2010-02-26	2010

	Row ID	Order ID	Order Date	Order Priority	Order Quantity	Sales	Discount	Ship Mode	Profit	Unit Price	Shipping Cost	Customer Name	Province	Region	Customer Segment	Product Category	Product Sub-Category	Product Name	Product Container	Product Base Margin	Ship Date	Year
8389	6492	46212	2012-09-12	Not Specified	43	322.4700	0.09	Express Air	72.2800	7.78	2.50	Grant Donatelli	Alberta	West	Consumer	Office Supplies	Envelopes	Staples #10 Colored Envelopes	Small Box	0.38	2012-09-14	2012
8390	6526	46437	2009-09-15	Medium	49	1488.6600	0.00	Regular Air	385.3700	29.34	7.87	Mick Brown	Alberta	West	Consumer	Furniture	Office Furnishings	Seth Thomas 14" Putty-Colored Wall Clock	Small Box	0.54	2009-09-17	2009
8391	6657	47360	2010-10-08	Not Specified	25	2200.6400	0.05	Delivery Truck	-514.1800	89.99	42.00	Frank Hawley	Alberta	West	Home Office	Furniture	Chairs & Chairmats	Global Leather Task Chair, Black	Jumbo Drum	0.66	2010-10-10	2010
8392	7396	52706	2012-07-09	Low	34	1041.6600	0.02	Express Air	480.5305	28.53	1.49	Harry Greene	Alberta	West	Corporate	Office Supplies	Binders and Binder Accessories	Lock-Up Easel 'Spel-Binder'	Small Box	0.38	2012-07-16	2012
8393	7586	54279	2011-07-30	High	41	10071.0900	0.10	Delivery Truck	1977.6900	264.98	17.86	Harry Greene	Alberta	West	Corporate	Technology	Office Machines	Panasonic KX-P1131 Dot Matrix Printer	Jumbo Drum	0.58	2011-07-31	2011
8394	7765	55558	2010-08-09	Medium	8	1294.0400	0.05	Delivery Truck	-323.1800	150.98	66.27	Mick Brown	Alberta	West	Consumer	Furniture	Bookcases	Bush Mission Pointe Library	Jumbo Box	0.65	2010-08-09	2010
8395	7766	55558	2010-08-09	Medium	23	392.5700	0.04	Regular Air	22.2500	17.07	8.13	Mick Brown	Alberta	West	Consumer	Office Supplies	Envelopes	Recycled Interoffice Envelopes with Re-Use-A-Seal® Closure, 10 x 13	Small Box	0.38	2010-08-11	2010
8396	7906	56550	2011-04-08	Not Specified	37	823.7800	0.03	Express Air	343.0500	22.23	5.08	Frank Hawley	Alberta	West	Home Office	Furniture	Office Furnishings	Executive Impressions 14"	Small Pack	0.41	2011-04-10	2011
8397	7907	56550	2011-04-08	Not Specified	8	469.8375	0.00	Regular Air	-159.2360	65.99	8.99	Frank Hawley	Alberta	West	Home Office	Technology	Telephones and Communication	Talkabout T8367	Small Box	0.56	2011-04-09	2011
8398	7914	56581	2009-02-08	High	20	2026.0100	0.10	Express Air	580.4300	105.98	13.99	Grant Donatelli	Alberta	West	Consumer	Furniture	Office Furnishings	Tenex 46" x 60" Computer Anti-Static Chairmat, Rectangular Shaped	Medium Box	0.65	2009-02-11	2009

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values